﻿CREATE TABLE [dbo].[Visit] (
    [VisitId]   INT           IDENTITY (1, 1) NOT NULL,
    [PatientId] INT           NOT NULL,
    [VisitDate] SMALLDATETIME NOT NULL,
    CONSTRAINT [PK_Visit] PRIMARY KEY CLUSTERED ([VisitId] ASC), 
    CONSTRAINT [FK_Visit_Patient] FOREIGN KEY ([PatientId]) REFERENCES [Patient]([PatientId])
);

